package com.ctshk.rpc.order.custom.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ctshk.rpc.order.custom.entity.CustomizedOrderTouristCertificate;

/**
 * <p>
 * 证件文件 Mapper 接口
 * </p>
 *
 * @author 叶冠峰
 * @since 2021-02-22
 */
public interface CustomizedOrderTouristCertificateMapper extends BaseMapper<CustomizedOrderTouristCertificate> {

	/**
	 * 查询旅客的证件文件路径列表
	 * @param tourist_id
	 * @return
	 */
	@Select("select t.file_path from t_customized_order_tourist_certificate t where t.is_deleted = 0 and t.tourist_id = #{touristId}")
	List<String> queryPathListByTourist(Long touristId);
}
